package com.evil.Test;

import com.evil.Bean.AnswerOverItemBean;
import com.evil.DAO.AnswerOverItemDAO;
import com.evil.DB_Utils.DB_Utils;
import com.evil.Data.Data;
import com.evil.Listener.ContextListener;
import com.evil.QuartzJob.CreateOverItemLogsJob;
import com.evil.Utils.Log;
import com.evil.Utils.Utils;
import com.google.gson.Gson;
import com.mysql.jdbc.Util;
import org.apache.log4j.Logger;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;

/******************************************
 * 工程名：EdaSupport<br>
 * 包名：<br>
 * 时间：2016年7月8日 下午9:56:16<br>
 * 作者：白雨濃 evil<br>
 * 邮箱：evilbai@foxmail.com<br>
 * 内容：<br>
 *
 *
 *
 *
 ******************************************/
public class Test
{
    public static void main(String args[]) throws ParseException
    {
        String url = "SELECT\n" + "	itemlist.item_id,\n" + "	itemlist.img,\n"
                + "	itemlist.title,\n" + "	itemlist.answer_ids,\n"
                + "	itemlist.type,\n" + "	itemlist.flow,\n"
                + "	itemlist.enabled,\n" + "	itemlist.create_time,\n"
                + "	itemlist.over_time\n" + "FROM\n" + "	itemlist\n"
                + "WHERE\n" + "	itemlist.item_id > ?\n"
                + "AND itemlist.item_id NOT IN (\n" + "	SELECT\n"
                + "		useroveritem.item_id\n" + "	FROM\n" + "		useroveritem\n"
                + "	WHERE\n" + "		useroveritem.phone = ?\n" + ")";

        Log.println(url.replaceAll("\n",""));

    }
}
